/**
 *
 */
package com.gxa.ehome.dao;

import com.gxa.ehome.entity.Cp;
import com.gxa.ehome.entity.vo.GetVo;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**
 * 实现User持久化方面的操作接口
 * @author bilei
 * @date 2021年3月8日
 */
public interface GetVoDao {

    //	List<Cp> selectAll() throws Exception;
    List<GetVo> selectByPage(int page, int size) throws Exception;

    List<GetVo> searchNameOrPhone(String nameOrphone, Integer page, Integer size) throws Exception;
//	Integer insert(Cp cp) throws Exception;
//	Cp selectById(Integer id) throws Exception ;
//	Integer update1(Integer id, Cp cp) throws Exception;

    List<Cp> selectNotGetCpsByPhone(String phone) throws Exception;


    List<Cp> selectGetCpsByPhone(String phone) throws Exception;


    List<Cp> selectOverExpireCpsByPhone(String phone) throws Exception;


    Integer getCpn(Integer cpId, String phone) throws Exception;
}
